﻿--Populate Subject Table

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31265, 'Communication for IT Professionals', 'Upon successful completion of this subject students should be able to construct and present written,  spoken and visual information with accuracy and clarity', 5, 'false');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31266, 'Introduction to Information Systems', 'This subject describes today business environment and how technology is integrated into businesses,  government and community systems.', 5, 'false');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (48023, 'Programming Fundamentals', 'This subject provides basic skills in Java programming and software design,  with no assumed knowledge of programming.', 5, 'false');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31268, 'Web Systems', 'In this subject,  skills are developed to use the computer as a tool for information processing,  and transfer over the internet.', 5, 'false');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31269, 'Business Requirements Modelling', 'This subject introduces information system concepts,  including their static and dynamic components.', 5, 'false');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31270, 'Networking Essentials',  'This subject introduces students to the fundamental issues in modern data communications and computer networks.' , 5, 'false');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31271, 'Database Fundamentals', 'Students are taught how data is structured and managed in an organisation in a way that can be used effectively by applications and users.', 5, 'false');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (48024, 'Applications Programming', 'This subject teaches students how to design,  develop and evaluate software systems to meet predefined quality characteristics of functionality (suitability) and usability (understandability,  learnability,  operability,  compliance). ', 5, 'true');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31251, 'Data Structures and Algorithms', 'This subject teaches students how to design,  develop and evaluate data structures and algorithms to meet predefined quality characteristics of functionality (suitability) and usability (understandability,  learnability,  operability,  compliance).', 5, 'true');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (48440, 'Software Engineering Practice', 'This subject introduces students to the fundamentals of contemporary software engineering. An overview of the agile and non-agile software engineering principles,  methods,  tools and techniques is presented. ', 5, 'true');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31260, 'Interface Design', 'This subject teaches students how to design,  implement and evaluate user interfaces to meet predefined quality characteristics of functionality (suitability),  usability (understandability,  learnability,  operability,  compliance) and portability (adaptability).', 5, 'true');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31253, 'Database Programming', 'This subject teaches students how to design,  develop and evaluate database programming and administration solutions to meet pre-defined quality characteristics of functionality (suitability,  security),  usability (operability),  efficiency (time behaviour,  resource utilisation),  and maintainability (changeability,  testability). ', 5, 'true');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31927, 'Application Development with .NET', 'This subject introduces C#,  Visual Studio and the .NET development environment. The emphasis is on examining the .NET framework and the practicalities of developing software in this setting using the C# language.', 5, 'true');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31100, 'Enterprise Development with .NET', 'The development of enterprise applications requires knowledge and skills spanning a range of technical areas. This subject focuses on the key components of enterprise applications and their implementation in .NET. Topics include enterprise application design,  security and data access. The language used is C#.', 5, 'true');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31284, 'Web Services Development', 'Web-based applications play an important role in contemporary commercial software development. This subject introduces concepts and technologies related to the development of modern web applications.', 5, 'true');

INSERT INTO [dbo].[Subject] ([SubjectId], [SubjectName], [Description], [Availability], [IfRequirePrerequisit]) 
VALUES (31242, 'Advanced Internet Programming', 'This subject provides students with knowledge of and skills in advanced Internet technologies particularly related to server-side Internet programming and business-to-business systems. ', 5, 'true');